package com.qinhailin.portal.dbm.service;

import java.util.List;

/** 2019-11-23 22:25:33 批量生成 harrydeep@wardyan.top **/
public class DPListtaskServiceImpl {

	@SuppressWarnings("unchecked")
	public List<Integer> dp_listtask(Integer pCustID){

		return (List<Integer>) com.jfinal.plugin.activerecord.Db.execute(new com.jfinal.plugin.activerecord.ICallback(){
			@Override
			public List<Integer> call(java.sql.Connection conn) throws java.sql.SQLException {
				java.sql.CallableStatement proc = conn.prepareCall("{call dp_listtask(?)}");
				proc.setInt(1,pCustID);

				java.sql.ResultSet rs = proc.executeQuery();

				
				java.util.List<Integer> list = new java.util.ArrayList<>();
				while(rs.next()){
					list.add(rs.getInt("sID"));

				}			
				return list;
			}
		});
	}
}

